﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$LocalizationDBConnection$" formatter="bizobjlist of TranslationTextSet">
	<Sql>
		SELECT        
			t1.textId, t1.translationId AS base_translationId, t1.text AS base_text, 
			t2.translationId AS trans_translationId, t2.text AS trans_text
		FROM            TranslationTexts AS t2 RIGHT OUTER JOIN
		TranslationTexts AS t1 ON t2.textId = t1.textId AND (t2.translationId = @transId OR
		t2.translationId IS NULL)
		WHERE        (t1.translationId = @baseId) AND (t2.translationId = @transId OR
		t2.translationId IS NULL)
		ORDER BY base_text
	</Sql>
	<Param name="baseId" type="UniqueIdentifier" />
	<Param name="transId" type="UniqueIdentifier" />
</AdoNetDataAccess>